package com.android.personal.data;

public class FinanceDataTags {

	protected static final String DATABASE_NAME = "personnal_finance_db_2";
	
	/**
	 * Accounts DB Requests functions.
	 * 
	 */
	
	protected static final String TABLE_ACCOUNTS = "accounts";

	public static final String ACCOUNT_KEY = "_id";
	public static final String ACCOUNT_NAME = "name";
	public static final String ACCOUNT_BALANCE = "balance";

	
	protected static final String DATABASE_CREATE_ACCOUNTS =
		" create table " + TABLE_ACCOUNTS + " ("
		+ ACCOUNT_KEY + " integer primary key autoincrement, "
		+ ACCOUNT_NAME + " text not null,"
		+ ACCOUNT_BALANCE + " integer not null);";
	
	/*************************************************/
	
	protected static final String TABLE_OPERATIONS = "operations";

	public static final String OPERATION_KEY = "_id";
	public static final String OPERATION_ACCOUNT_ID = "operation_account_id";
	public static final String OPERATION_VALUE = "operation_value";
	public static final String OPERATION_DATE = "operation_date";
	public static final String OPERATION_CATEGORY = "operation_category";

	
	protected static final String DATABASE_CREATE_OPERATIONS =
		" create table " + TABLE_OPERATIONS + " (" 
		+ OPERATION_KEY + " integer primary key autoincrement, "
		+ OPERATION_ACCOUNT_ID + " integer not null,"
		+ OPERATION_VALUE + " integer not null,"
		+ OPERATION_DATE + " date not null,"
		+ OPERATION_CATEGORY + " text not null);";
	
	public static final String OPERATION_YEAR = "operation_year";
	public static final String OPERATION_MONTH = "operation_month";
	public static final String OPERATION_DAY = "operation_day";
	
}
